This report takes the SQL outputs and runs some initial trend analysis to visualise any outliers/pull out key trends ahead of writing any commentary.
This section checks the national trends over the last 4 years to make sure the data is looking sensible
The following checks look at pupil numbers by year
The following checks look at average attainment 8 by year. The maximum attainment 8 score is 90.
The following checks look at the percentage of pupils achieving 9-5 in Level 2 basics by year.
The following checks look at percentage of pupils entering the EBacc by year.
The following checks look at percentage of pupils acheiving levels 9-5 in the EBacc by year.
The following checks look at the EBacc average point score by year.
This section checks the local authority trends over the last 4 years to make sure the data is looking sensible.
Double click a region in the legend to isolate the LAs inside it.
This section looks at the difference in various measures between pupils in the different social care groups and “all pupils”, year to year
For non calculated columns (i.e. not average or percentage), the LA subtotals should add up to their region totals. A table will display below of the regions and years that do not match if this is not the case.
## [1] "LA subtotals add up to their region totals"
Region subtotals should not add up to the national total as different filters are used. The table below shows the difference between regional subtotals and national figures.
| time_period | t_pupils_diff | t_att8_diff | t_l2basics_95_diff | t_l2basics_94_diff | t_ebacc_e_ptq_ee_diff | t_ebacc_95_diff | t_ebacc_94_diff | t_ebaccaps |
|---|---|---|---|---|---|---|---|---|
| 201617 | 40519 | 864689.8 | 4978 | 9786 | 6402 | 2280 | 2716 | 0.00 |
| 201718 | 43793 | 920322.7 | 5355 | 9756 | 7442 | 1774 | 2983 | 75628.94 |
| 201819 | 76295 | 1918139.8 | 11992 | 22080 | 16692 | 4159 | 7064 | 160776.08 |
| 201920 | 81308 | 2260787.8 | 15636 | 27983 | 18218 | 5897 | 9779 | 189859.48 |
Bournemouth, Poole and Dorset all ceased to be LAs from 201920, so shouldn’t exist in our 201920 data. A table will display below of rows where this is not the case.
| time_period | region_name | la_name | new_la_code | social_care_group | pupil_sen_status | t_pupils |
|---|---|---|---|---|---|---|
| 201920 | South West | Dorset (up to 2019) | E10000009 | Ever CIN - last 6 years | All pupils | 477 |
| 201920 | South West | Dorset (up to 2019) | E10000009 | Ever CIN - last 6 years | No identified SEN | 246 |
| 201920 | South West | Dorset (up to 2019) | E10000009 | Ever CIN - last 6 years | All SEN | 192 |
| 201920 | South West | Dorset (up to 2019) | E10000009 | Ever CIN - last 6 years | Statement or EHC plan | 75 |
| 201920 | South West | Dorset (up to 2019) | E10000009 | Ever CIN - last 6 years | SEN support | 117 |
| 201920 | South West | Poole (up to 2019) | E06000029 | Ever CIN - last 6 years | All pupils | 251 |
| 201920 | South West | Poole (up to 2019) | E06000029 | Ever CIN - last 6 years | No identified SEN | 127 |
| 201920 | South West | Poole (up to 2019) | E06000029 | Ever CIN - last 6 years | All SEN | 104 |
| 201920 | South West | Poole (up to 2019) | E06000029 | Ever CIN - last 6 years | Statement or EHC plan | 29 |
| 201920 | South West | Poole (up to 2019) | E06000029 | Ever CIN - last 6 years | SEN support | 75 |
| 201920 | South West | Bournemouth (up to 2019) | E06000028 | Ever CIN - last 6 years | All pupils | 230 |
| 201920 | South West | Bournemouth (up to 2019) | E06000028 | Ever CIN - last 6 years | No identified SEN | 120 |
| 201920 | South West | Bournemouth (up to 2019) | E06000028 | Ever CIN - last 6 years | All SEN | 85 |
| 201920 | South West | Bournemouth (up to 2019) | E06000028 | Ever CIN - last 6 years | Statement or EHC plan | 36 |
| 201920 | South West | Bournemouth (up to 2019) | E06000028 | Ever CIN - last 6 years | SEN support | 49 |
“Bournemouth, Chirstchurch and Poole” became a single LA in 201920, so shouldn’t exist in any data from before 201920. A table will display below of rows where this is not the case.
| time_period | region_name | la_name | new_la_code | social_care_group | pupil_sen_status | t_pupils |
|---|---|---|---|---|---|---|
| 201617 | South West | Bournemouth, Christchurch and Poole (2020 onwards) | E06000058 | CLA at any point | All pupils | 0 |
| 201617 | South West | Bournemouth, Christchurch and Poole (2020 onwards) | E06000058 | CLA at any point | No identified SEN | 0 |
| 201617 | South West | Bournemouth, Christchurch and Poole (2020 onwards) | E06000058 | CLA at any point | All SEN | 0 |
| 201617 | South West | Bournemouth, Christchurch and Poole (2020 onwards) | E06000058 | CLA at any point | Statement or EHC plan | 0 |
The number of pupils achieving a 9-4 in English and Maths should be greater than or equal to the number achieving a 9-5. A table below will appear showing all rows where this is not the case, if any exist.
## [1] "The number of pupils achieving a 9-4 in English and maths is greater than or equal to the number achieving a 9-5"
The number of pupils achieving a 9-4 in EBacc subjects should be greater than or equal to the number achieving a 9-5. A table below will appear showing all rows where this is not the case, if any exist.
## [1] "The number of pupils achieving a 9-4 in EBacc is greater than or equal to the number achieving a 9-5"
The totals for SEN pupils with and without statements should add up to the totals for all SEN pupils. A table below will appear showing all rows where this is not the case, if any exist.
## [1] "The totals for SEN pupils with a statment and SEN pupils without a statement add up to the totals for all SEN"
The total SEN and no identified SEN will not add up to “all pupils” as there is an “unknown” category too which is not accounted for here.
A small percentage of pupils each year have an unknown SEN status. The table below shows this number and the number as a percentage of all pupils.
| time_period | t_pupils_unknown | t_pupils_unknown_perc |
|---|---|---|
| 201617 | 19698 | 0.1 |
| 201718 | 23505 | 0.1 |
| 201819 | 38713 | 0.1 |
| 201920 | 50627 | 0.1 |
In theory CIN = CINO + CPPO + CLA, however, in practice they won’t add up exactly as some CLA do not match to CIN. However, it would be good to do some checks on this to see the scale of the differences. This looks at the number of pupils each year for the following caluclations to check:
CIN_At31 – CINO_At31 – CPPO_At31 - CLA_12Months – CLA_Less_12Months_At31 as a percentage of CLA_12Months + CLA_Less_12Months_At31
CIN_AnyPoint – CINO_AnyPoint – CPPO_AnyPOint - CLA_Anypoint as a percentage of CLA_Anypoint
| time_period | CIN_31_check | CIN_31_check_perc | CIN_any_check | CIN_any_check_perc |
|---|---|---|---|---|
| 201617 | -1517 | -23.4 | 3269 | 44.4 |
| 201718 | -1338 | -20.4 | 3408 | 46.4 |
| 201819 | -1389 | -20.3 | 3849 | 50.8 |
| 201920 | -1364 | -18.6 | 3903 | 48.0 |